{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Help"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Storage Rental Customer Database"]
[]
[]
[null,null,null,"number of customers:",3]
[]
["Name (Last, First)","Permanent Address","Current Address","Cubic Foot Usage","Rental Cost","Amount Paid","Remaining Balance","Renting?"]
["Fisher, Zack","Sample","Provo",17,102,60,42,"N"]
["Nielsen, Jacob","3519 NW Robin Pl., Corvallis, OR, 97330","674 E 800 N, Provo, UT, 84606",50,500,32,468,"Y"]
["Mukattash, Izzat","Sample","Provo",10,50,35,15,"N"]
[]
[null,null,null,"Total",652]

{"sheet":"Help","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Purpose:"]
[null,"This customer database is designed to keep track of customers that have a remaining balance on their account.  It keeps track of how much cubic footage the customer is using and the associated charges for the amount of space rented.  This database's objective is to efficiently track a customers billing information. The spreadsheet allows the owner to edit the customers information and keep track of which customers are still renting space, and who only have a remaining balance."]
[]
["How to add a customer:"]
[null,"When you click on \"Add Customer\" the window on the right will come up. Then you will enter the information of the new customer you want to add. When finished press \"OK\" to upload the information into the data sheet. Or if you decide to cancel the process simply press \"Cancel\" that will take you to the main page and no information will be uploaded."]
[]
["How to edit a customer:"]
[null,"When a mistake happens or you decide to edit some information on the data sheet. Simply press on \"Edit Customer\". The window on the right side will show up. You then will have the option to choose, the name of the customer you want to edit, from the list and then apply the changes. When done press \"OK\" that will apply the changes and take you to the main page. If decided to cancel the process, you could simply press \"Cancel\" that will directly take you back to the main page and no changes will be applied. "]
[]
["How to delete a customer:"]
[null,"As you want to delete a customer from the data sheet. The option \"Delete Customer\" will help you choose which customer you wish to delete. Select the customer you wish to delete then you can press \"OK\", that will apply the changes, delete the customer and take you to the main page. If decided to cancel the process, you can simply press \"Cancel\" that will directly take you back to the main page and no changes will be applied."]
[]
["How to make a payment:"]
[null,"When it comes to organizing customer payments. You can simply press on \"Make a Payment\" that will enable you to add the amount of money paid towards the storage fee. Using Visual Basic code, the data sheet will automatically upload the payment under column \"Amount\" and then calculate the rest of the money that needs to be paid and upload under \"Balance\". When the window shows up after pressing on \"Make a Payment\" you select the name of the customer and type the amount they paid. After that, press \"OK\" to upload the information and go back to the main sheet. Or press \"Cancel\" to go back to the main sheet with no information changing."]